<?php
  $option = array(); //prevent problems
  $option['driver']   = 'mysql';            // Database driver name
  $option['host']     = 'mysql.pensareweb.it';    // Database host name
  $option['user']     = 'clubres_test';       // User for database authentication
  $option['password'] = 'VjA5dhbg';   // Password for database authentication
  $option['database'] = 'clubres_test';      // Database name
  $option['prefix']   = '';             // Database prefix (may be empty)
  $db = & JDatabase::getInstance( $option );
  
                if ( JError::isError($db) ) {
                        jexit('Database Error: ' . $db->toString() );
                }
                if ($db->getErrorNum() > 0) {
                        JError::raiseError(500, 'JDatabase::getInstance: Could not connect to database <br />');
                }  
  
  echo '1';
  //$query = "SELECT * FROM CANTINE";
  //$db->setQuery($query);
  //$DataSet = $db->loadAssocList();
  //echo '2';
  //foreach($DataSet as $r) {
  //  echo $r[0],' | ',$r[1],' | ', $r[2],    '<br />';
 // }
?>